SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 49134: Trying to share a LIBNAME connection when accessing DB2 on a z/OS system might result in "System abend 0C4"

DetailsHotfixAboutRate It

An abend 0C4 error might occur when you try to share connections with multiple librefs with the DB2 engine when running the SAS® system in a z/OS operating environment. The error might look similar to the following:

ERROR: System abend 0C4 occurred in module SASHOST function
db2m_compare_conn_options at offset E56D64.


 ERROR: Traceback will be attempted...

 NOTE: Traceback called
 NOTE:  Module  Function Offset Line
 NOTE: -------- -------- ------ ----
 NOTE: SASXDBI    DBICON 000B78    0
 NOTE: SASXDBI   YHELASG 000808    0
 NOTE: SASYH     YYHLASN 0002F8    0
 NOTE: SASYH     YHLASN2 000AC4    0
 NOTE: SASXSHEL   YTLIBF 000A38    0
 NOTE: SASXSHEL   YASANY 000632    0
 NOTE: SASXSHEL  YASANY2 000142    0
 NOTE: SASXSHEL   YTTKNX 001E6E    0
 NOTE: SASXSHEL  YALEXEC 001F96    0
 NOTE: SASXSHEL  YALINLN 000516    0

To work around the issue, do either of the following when you are attempting to share DB2 connections:

  • Explicitly list the DB2 subsystem using the SSID= option
  • Or use the SQL_FUNCTIONS=ALL option in each of the LIBNAME statements

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9.2 TS2M39.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.